package com.xiaohu.mayi_huiyuan.mapper;

import com.xiaohu.mayi_huiyuan.entity.Yuebiao;
import com.xiaohu.mayi_huiyuan.entity.YuebiaoExample;

import java.math.BigDecimal;
import java.util.List;

import com.xiaohu.mayi_huiyuan.model.YueBiaoDto;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface YuebiaoMapper {
    int countByExample(YuebiaoExample example);

    int deleteByExample(YuebiaoExample example);

    int deleteByPrimaryKey(Integer id);

    int insert(Yuebiao record);

    int insertSelective(Yuebiao record);

    List<Yuebiao> selectByExample(YuebiaoExample example);

    Yuebiao selectByPrimaryKey(Integer id);

    int updateByExampleSelective(@Param("record") Yuebiao record, @Param("example") YuebiaoExample example);

    int updateByExample(@Param("record") Yuebiao record, @Param("example") YuebiaoExample example);

    int updateByPrimaryKeySelective(Yuebiao record);

    int updateByPrimaryKey(Yuebiao record);


    Double selctMaxChongzhiYue(Integer customerId);

    Double selctMaxFanXianYue(Integer customerId);

    List<YueBiaoDto>getAllYueBiao();

    BigDecimal getChongZhieSum();

    BigDecimal getChongZhiXiaoFei();

    BigDecimal getFanXianAll();
}
